SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 58973: The ANYDTDTE, ANYDTDTM, and ANYDTTME informats do not read special missing values correctly

DetailsCodeAboutRate It

When reading numeric data into SAS®, it is often helpful to assign characters in your input data to represent special missing values for numeric data. The MISSING statement specifies the value in your input data that represents a special missing value. This can be any of the letters of the alphabet or the underscore character.

The ANYDTDTE, ANYDTDTM, and ANYDTTME informats do not read the special missing values correctly. Instead of showing the letter or underscore from the input data in the output, a period is shown instead.

To circumvent the problem, use a different informat to read the input data that contains special missing values.

The sample code on the Full Code tab illustrates the problem and a circumvention.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASHP-UX IPF9.3 TS1M09.4 TS1M5
64-bit Enabled Solaris9.3 TS1M09.4 TS1M5
64-bit Enabled HP-UX9.3 TS1M09.4 TS1M5
64-bit Enabled AIX9.3 TS1M09.4 TS1M5
Windows Vista for x649.3 TS1M0
Windows Vista9.3 TS1M0
Windows 7 Ultimate x649.3 TS1M09.4 TS1M5
Windows 7 Ultimate 32 bit9.3 TS1M09.4 TS1M5
Windows 7 Professional x649.3 TS1M09.4 TS1M5
Windows 7 Professional 32 bit9.3 TS1M09.4 TS1M5
Windows 7 Home Premium x649.3 TS1M09.4 TS1M5
Windows 7 Home Premium 32 bit9.3 TS1M09.4 TS1M5
Windows 7 Enterprise x649.3 TS1M09.4 TS1M5
Windows 7 Enterprise 32 bit9.3 TS1M09.4 TS1M5
Microsoft Windows XP Professional9.3 TS1M0
Microsoft Windows Server 2008 for x649.3 TS1M0
Microsoft Windows Server 2008 R29.3 TS1M0
Microsoft Windows Server 20089.3 TS1M0
Microsoft Windows Server 2003 for x649.3 TS1M0
Microsoft Windows Server 2003 Standard Edition9.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.3 TS1M0
Microsoft® Windows® for x649.3 TS1M09.4 TS1M5
z/OS 64-bit9.3 TS1M09.4 TS1M5
z/OS9.3 TS1M09.4 TS1M5
Linux9.3 TS1M09.4 TS1M5
Linux for x649.3 TS1M09.4 TS1M5
Solaris for x649.3 TS1M09.4 TS1M5
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.